CREATE DATABASE  IF NOT EXISTS `calypso` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `calypso`;
-- MySQL dump 10.13  Distrib 5.1.40, for Win32 (ia32)
--
-- Host: localhost    Database: calypso
-- ------------------------------------------------------
-- Server version	5.1.50-community

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `items`
--

DROP TABLE IF EXISTS `items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `omschrijving` varchar(45) DEFAULT NULL,
  `foto` varchar(45) DEFAULT NULL,
  `vrijdag` int(11) DEFAULT NULL,
  `zaterdag` int(11) DEFAULT NULL,
  `zondag` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=277 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `items`
--

LOCK TABLES `items` WRITE;
/*!40000 ALTER TABLE `items` DISABLE KEYS */;
INSERT INTO `items` VALUES (5,'Kapstok pampers','IMG_0189.JPG',1,1,0),(6,'Bezem','IMG_0191.JPG',0,1,1),(7,'Carlsberg glas','IMG_0192.JPG',2,2,2),(8,'Calypso pot','IMG_0193.JPG',10,10,10),(9,'Steel power tape meter','IMG_0194.JPG',1,1,0),(10,'Normann notitieboek','IMG_0195.JPG',1,0,0),(11,'Bak en grill penseel','IMG_0196.JPG',0,1,0),(12,'Handoek haak tesa','IMG_0197.JPG',0,0,1),(13,'Potloden Stabilo','IMG_0199.JPG',0,0,1),(14,'Lijm stick','IMG_0198.JPG',1,0,0),(15,'Tafelkleed','IMG_0207.JPG',0,0,1),(16,'Wijnstop','IMG_0205.JPG',0,0,1),(17,'Map Atoma','IMG_0202.JPG',1,0,0),(18,'Flessenhouder','IMG_0204.JPG',0,1,0),(19,'Ijsblok maker','IMG_0203.JPG',0,1,0),(20,'Schaal','IMG_0206.JPG',0,0,1),(22,'Waardebon','IMG_0200.JPG',0,0,1),(23,'Teenslippers','IMG_0208.JPG',1,1,1),(24,'KBC notitieboekje','IMG_0209.JPG',0,1,0),(25,'Vaas','IMG_0201.JPG',0,0,1),(26,'DVD Robbedoes','IMG_0210.JPG',1,0,0),(27,'Kaarshouder','IMG_0211.JPG',0,0,1),(28,'Kaars','IMG_0212.JPG',1,1,0),(29,'Pennendoos','IMG_0215.JPG',1,0,0),(30,'Brooddoos','IMG_0214.JPG',0,0,1),(31,'Jojo','IMG_0213.JPG',1,1,2),(32,'DVD Tom en Jerry','IMG_0216.JPG',0,1,0),(33,'Pennendoos','IMG_0217.JPG',1,0,0),(34,'Bob de bouwer strip','IMG_0218.JPG',0,1,1),(35,'Nero strip','IMG_0219.JPG',0,0,1),(36,'Nero strip','IMG_0220.JPG',0,1,0),(37,'Nero strip','IMG_0221.JPG',1,0,0),(38,'Suske en wiske strip','IMG_0222.JPG',1,0,0),(39,'Suske en wiske strip','IMG_0223.JPG',0,1,0),(40,'Max de muis boek','IMG_0224.JPG',0,0,1),(41,'Het zevende geitje boek','IMG_0225.JPG',0,1,0),(42,'Suske en wiske boek','IMG_0226.JPG',1,0,0),(43,'La choufe fles','IMG_0227.JPG',1,1,2),(44,'Spaarpotje filou','IMG_0228.JPG',0,1,1),(45,'Tas Berner','IMG_0229.JPG',1,0,0),(46,'Ecobo flesopener','IMG_0230.JPG',0,1,0),(47,'Broche','IMG_0231.JPG',0,0,1),(48,'Uurwerk','IMG_0232.JPG',1,0,0),(49,'Tas Novatio','IMG_0233.JPG',0,1,0),(50,'Tas Felix','IMG_0234.JPG',1,0,0),(51,'Tas Graindor','IMG_0235.JPG',0,0,1),(52,'Wereld atlas','IMG_0236.JPG',0,1,0),(53,'Juwelenzakje','IMG_0237.JPG',0,0,1),(54,'Blik cooler','IMG_0238.JPG',0,0,1),(55,'Neklint sleutel hangel stella','IMG_0239.JPG',0,1,1),(56,'Ijstang','IMG_0240.JPG',1,0,0),(57,'Spaarpot','IMG_0241.JPG',1,0,0),(58,'knuffel','IMG_0242.JPG',1,0,0),(59,'Knuffel','IMG_0243.JPG',0,1,0),(60,'Kader','IMG_0244.JPG',1,0,0),(61,'Strandmat cola','IMG_0245.JPG',0,0,1),(62,'Rugzak','IMG_0246.JPG',0,0,1),(63,'Zak festival','IMG_0247.JPG',0,1,0),(64,'Teenslippers','IMG_0248.JPG',0,1,0),(65,'Doorzichtige zak','IMG_0249.JPG',1,0,0),(66,'Brooddoos','IMG_0250.JPG',0,0,1),(67,'Doek Aquarius','IMG_0251.JPG',1,0,0),(68,'Zonnescherm','IMG_0252.JPG',0,0,1),(69,'Spel brandweer','IMG_0253.JPG',0,0,1),(70,'Petanque','IMG_0254.JPG',0,1,0),(71,'Thee licht glaasjes','IMG_0255.JPG',1,1,0),(72,'Ijs glas','IMG_0256.JPG',2,2,1),(73,'Sleutel ecobo','IMG_0257.JPG',1,0,0),(74,'Kerst tas','IMG_0258.JPG',0,0,1),(75,'Knuffel','IMG_0259.JPG',1,0,0),(76,'Knuffel','IMG_0260.JPG',1,0,0),(77,'2 Eierdopjes licht blauw','IMG_0261.JPG',0,0,2),(78,'2 Eierdopjes geel ','IMG_0262.JPG',2,2,0),(79,'2 Eierdopjes donker blauw','IMG_0263.JPG',0,2,0),(80,'Portefeuille','IMG_0264.JPG',1,0,0),(81,'Portefeuille','IMG_0265.JPG',0,1,0),(82,'Verfdoos','IMG_0266.JPG',0,0,1),(83,'Tegels pampers','IMG_0267.JPG',0,1,0),(84,'Scheef vaasje','IMG_0268.JPG',1,2,1),(85,'2 Druppel glaasjes','IMG_0269.JPG',1,1,1),(86,'Magnetix spel','IMG_0270.JPG',0,1,0),(87,'Schilderijtje','IMG_0271.JPG',1,0,0),(88,'Vaas','IMG_0272.JPG',0,0,1),(89,' Boodschappen zak','IMG_0273.JPG',0,1,0),(90,'Knuffel','IMG_0274.JPG',1,1,1),(91,'Knuffel','IMG_0275.JPG',1,1,1),(92,'2 Vittel glazen','IMG_0276.JPG',1,1,1),(93,'Regenkapje','IMG_0277.JPG',3,4,3),(94,'Auto manitou','IMG_0278.JPG',0,0,1),(95,'Zakje','IMG_0279.JPG',2,2,1),(96,'Zakje','IMG_0280.JPG',1,2,2),(97,'Pennenzak','IMG_0281.JPG',0,1,1),(98,'Pennenzak','IMG_0282.JPG',1,1,0),(99,'Zak','IMG_0283.JPG',0,0,1),(100,'Dobbel bak','IMG_0284.JPG',0,1,0),(101,'Omtrek hoofdkussen','IMG_0285.JPG',1,1,0),(102,'Vogelkastje','IMG_0286.JPG',1,0,0),(103,'Aansteker','IMG_0287.JPG',1,2,2),(104,'Frisco vorm','IMG_0288.JPG',0,0,1),(105,'Zonnebril','IMG_0289.JPG',1,0,0),(106,'Flesje','IMG_0290.JPG',1,0,0),(107,'Kaars','IMG_0291.JPG',0,0,1),(108,'Brievenhouder','IMG_0292.JPG',0,1,0),(109,'USB stick','IMG_0293.JPG',1,0,0),(110,'Notitieblok skylux','IMG_0294.JPG',12,12,12),(111,'Tekening kerk','IMG_0295.JPG',1,0,0),(112,'Glas 2000','IMG_0296.JPG',0,1,0),(113,'Muts leo','IMG_0298.JPG',3,3,2),(114,'Kousen kerst','IMG_0299.JPG',0,1,0),(115,'Sleutelhanger leo','IMG_0300.JPG',0,0,1),(116,'Strandzak','IMG_0301.JPG',1,0,0),(117,'Vlieger','IMG_0302.JPG',0,1,0),(118,'Autos','IMG_0303.JPG',0,0,1),(119,'Hand en body','IMG_0304.JPG',1,0,0),(120,'Emmer','IMG_0305.JPG',0,1,0),(121,'Dreft beker','IMG_0306.JPG',0,0,1),(122,'Rekenmachine','IMG_0307.JPG',1,0,0),(123,'Champagne koeler','IMG_0308.JPG',0,0,1),(124,'Boek Kato','IMG_0309.JPG',0,0,1),(125,'Auto en stiftjes','IMG_0310.JPG',0,0,1),(126,'Stiftjes met potloden','IMG_0311.JPG',1,0,0),(127,'Knuffel','IMG_0312.JPG',1,0,0),(128,'DVD tom en jerry','IMG_0313.JPG',0,1,0),(129,'Boek Baas in eigen bos','IMG_0314.JPG',0,1,0),(130,'Was handschoen (meerdere kleuren)','IMG_0315.JPG',1,2,1),(131,'meter','IMG_0316.JPG',0,1,1),(132,'tasje','IMG_0317.JPG',1,0,0),(133,'tasje','IMG_0318.JPG',0,1,0),(134,'aanstekers','IMG_0319.JPG',6,6,6),(135,'Stylo skylux','IMG_0335.JPG',100,100,100),(136,'Bal','IMG_0320.JPG',2,2,1),(137,'Stylo shell','IMG_0322.JPG',8,8,7),(138,'Stylo primagaz','IMG_0323.JPG',1,2,2),(139,'Spons texaco','IMG_0321.JPG',2,2,1),(140,'Waterspuit en spel','IMG_0324.JPG',0,1,0),(141,'Rendier oren','IMG_0325.JPG',1,0,0),(142,'Kousen','IMG_0326.JPG',0,1,1),(143,'Freesbie','IMG_0327.JPG',1,0,0),(144,'Tasje','IMG_0328.JPG',0,1,1),(145,'Kaderke','IMG_0329.JPG',1,0,1),(146,'mandje','IMG_0330.JPG',0,0,1),(147,'portemonee','IMG_0331.JPG',0,1,0),(148,'Flessenhouder','IMG_0332.JPG',1,0,0),(149,'knuffel','IMG_0333.JPG',1,0,0),(150,'Eendje','IMG_0334.JPG',0,1,0),(151,'Kaarshouder','IMG_0341.JPG',0,0,1),(152,'Eendje','IMG_0342.JPG',0,0,1),(153,'Termometer','IMG_0343.JPG',0,0,1),(154,'Beertje','IMG_0344.JPG',1,0,0),(155,'beeldje','IMG_0345.JPG',1,0,0),(156,'Schoentrekker','IMG_0346.JPG',1,1,2),(157,'Flesopenner','IMG_0347.JPG',1,2,2),(158,'veters','IMG_0348.JPG',1,1,1),(159,'Hoofdprijs knuffel','IMG_0349.JPG',1,1,1),(160,'Onderleggers (allemaal)','IMG_0350.JPG',1,0,0),(161,'T-Shirt snareline','IMG_0351.JPG',0,0,1),(162,'Notitieblaadjes roose','IMG_0352.JPG',1,2,2),(163,'zak ice tea','IMG_0353.JPG',0,1,0),(164,'inlegzool','IMG_0354.JPG',0,1,2),(165,'Inlegzool groen of roze','IMG_0355.JPG',2,0,0),(166,'Zak Renault','IMG_0356.JPG',1,0,0),(167,'Inlegzolen zilver','IMG_0357.JPG',0,1,0),(168,'Riem','IMG_0358.JPG',20,20,20),(169,'beeldje zwaan','IMG_0359.JPG',0,1,0),(170,'beeldje kikker','IMG_0360.JPG',0,0,1),(171,'Beeldje kikker','IMG_0361.JPG',0,1,0),(172,'Beeld schoen','IMG_0362.JPG',1,0,0),(173,'Fluit','IMG_0363.JPG',1,0,0),(174,'Kruiwagen','IMG_0364.JPG',0,0,1),(175,'Sponsje (meerdere kleuren)','IMG_0365.JPG',8,8,8),(176,'Kam','IMG_0366.JPG',17,17,18),(177,'Kaarshouder','IMG_0367.JPG',0,0,1),(178,'Sponsjes','IMG_0368.JPG',4,4,4),(179,'Kaarsjes','IMG_0369.JPG',0,0,1),(180,'Puzzel','IMG_0370.JPG',0,0,1),(181,'Stiften','IMG_0371.JPG',1,2,2),(182,'beeldje','IMG_0372.JPG',0,1,0),(183,'Kaars','IMG_0373.JPG',1,0,0),(184,'Was handschoen','IMG_0374.JPG',0,1,0),(185,'Kousjes','IMG_0375.JPG',0,1,0),(186,'Kalender','IMG_0376.JPG',8,9,9),(187,'Rekenmachine','IMG_0377.JPG',1,0,0),(188,'Dressing maker','IMG_0378.JPG',1,0,0),(189,'Kam met witte rand','IMG_0379.JPG',3,3,2),(190,'Kam','IMG_0380.JPG',2,1,2),(191,'Kam','IMG_0381.JPG',0,1,0),(192,'Zak','IMG_0382.JPG',1,0,0),(193,'Zak espagna','IMG_0383.JPG',0,0,1),(194,'Juwelen','IMG_0384.JPG',1,0,0),(195,'Potjes','IMG_0385.JPG',0,1,0),(196,'Beeldje','IMG_0386.JPG',0,1,0),(197,'Ventilator','IMG_0387.JPG',0,0,1),(198,'Potje','IMG_0388.JPG',1,0,0),(199,'Juwelen','IMG_0389.JPG',0,0,1),(200,'Zak Tetra','IMG_0390.JPG',0,1,0),(201,'Zak Renault','IMG_0391.JPG',1,0,0),(202,'Deur stopper','IMG_0392.JPG',0,1,0),(203,'Klok cola','IMG_0393.JPG',1,0,0),(204,'Bad kussen','IMG_0394.JPG',0,0,1),(205,'Nek hanger jupiler','IMG_0395.JPG',1,0,0),(206,'Nekhanger Proximus','IMG_0396.JPG',0,1,0),(207,'Keuken pers','IMG_0397.JPG',0,1,0),(208,'Poffertjes pan','IMG_0398.JPG',0,0,1),(209,'Voetbad','IMG_0399.JPG',0,0,1),(210,'Lepels','IMG_0400.JPG',1,0,0),(211,'Waardebon',NULL,16,16,17),(212,'Wekker KBC','IMG_0402.JPG',0,1,1),(213,'Drinkbeker Isostar','IMG_0403.JPG',1,0,1),(214,'Pet','IMG_0404.JPG',0,0,1),(215,'Pet','IMG_0405.JPG',0,1,0),(216,'Handschoen','IMG_0406.JPG',0,0,1),(217,'Knuffel','IMG_0407.JPG',0,0,1),(218,'Stylo kbc','IMG_0408.JPG',1,1,0),(219,'afkletser kbc','IMG_0409.JPG',1,0,0),(220,'Handdoek','IMG_0410.JPG',0,1,0),(221,'Schaaltje','IMG_0411.JPG',0,1,0),(222,'Schaaltje','IMG_0412.JPG',1,0,0),(223,'Tas','IMG_0413.JPG',0,0,1),(224,'Moto','IMG_0414.JPG',0,1,0),(225,'zak kbc','IMG_0415.JPG',1,0,0),(226,'slabbetje','IMG_0416.JPG',0,0,1),(227,'Boek Loving You','IMG_0417.JPG',0,0,1),(228,'Tijdschrift knipple','IMG_0418.JPG',0,1,0),(229,'P-Magazine','IMG_0419.JPG',1,1,0),(230,'Lord of the rings contactboek','IMG_0421.JPG',1,0,0),(231,'Boek Klimt','IMG_0422.JPG',0,0,1),(232,'Mijn geld','IMG_0423.JPG',0,1,0),(233,'Verrassingsboek','IMG_0424.JPG',1,0,0),(234,'Boek w817','IMG_0425.JPG',0,0,1),(235,'Boek spring','IMG_0426.JPG',1,1,0),(236,'Fiets bel','IMG_0427.JPG',0,0,1),(237,'Bass onderlegger','IMG_0428.JPG',2,1,1),(238,'Hoefijzer kbc','IMG_0429.JPG',1,1,0),(239,'Kaars','IMG_0430.JPG',0,0,1),(240,'Peper en zout vat','IMG_0431.JPG',0,1,0),(241,'Onderleggers Cristal','IMG_0432.JPG',0,1,0),(242,'CD Sinterklaas','IMG_0433.JPG',1,0,0),(243,'CD Zo is er maar 1','IMG_0434.JPG',0,1,0),(244,'CD Gene thomas','IMG_0435.JPG',1,0,1),(245,'cd Nonkel bob','IMG_0436.JPG',0,0,1),(246,'Smaak van de keizer','IMG_0437.JPG',1,2,1),(247,'DVD Debby en nancy','IMG_0438.JPG',0,1,0),(248,'Verrassings dvd','IMG_0439.JPG',1,0,0),(249,'BBQ set','IMG_0454.JPG',4,4,4),(250,'Bal jupiler','IMG_0453.JPG',2,2,1),(251,'T-Shirt jupiler','IMG_0452.JPG',3,2,2),(252,'bal spar','IMG_0449.JPG',1,0,0),(253,'Boek medische encyclopedie','IMG_0440.JPG',0,0,1),(254,'Dag allemaal','IMG_0441.JPG',1,0,0),(255,'Boek Intramuros','IMG_0442.JPG',0,1,0),(256,'Knuffel','IMG_0443.JPG',1,0,0),(257,'Muts kbc','IMG_0444.JPG',0,0,1),(258,'Tafelkleedje','IMG_0445.JPG',0,1,0),(259,'Potje Ricola','IMG_0446.JPG',0,1,1),(260,'Tuinkabouter','IMG_0447.JPG',0,1,0),(261,'Beeldje jongen','IMG_0448.JPG',1,0,0),(262,'Schaaltje','IMG_0450.JPG',1,1,0),(263,'Kaarshouder','IMG_0451.JPG',0,0,1),(264,'Drinkfles Schweppes','IMG_0455.JPG',2,1,1),(265,'Theelicht houder Coca Cola','IMG_0456.JPG',2,2,2),(266,'Pet','IMG_0457.JPG',0,1,0),(267,'Theelicht houder coca cola','IMG_0458.JPG',1,0,0),(268,'T-Shirt beckers','IMG_0459.JPG',0,0,1),(269,'T-Shirt Delizio','IMG_0460.JPG',0,1,0),(270,'Speeltje','IMG_0461.JPG',7,7,6),(271,'Stylo Sebas','IMG_0462.JPG',5,5,4),(272,'Aansteker','IMG_0463.JPG',2,3,3),(273,'Bruine tas','IMG_0464.JPG',0,0,1),(274,'Theepot en melkkan','IMG_0465.JPG',0,0,1),(275,'Tapijtje','IMG_0466.JPG',1,0,0),(276,'Tafellapje','IMG_0467.JPG',0,0,1);
/*!40000 ALTER TABLE `items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `codes`
--

DROP TABLE IF EXISTS `codes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `codes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `itemId` int(11) DEFAULT NULL,
  `day` int(11) DEFAULT NULL COMMENT '1 = vrijdag\n2= zaterdag\n3 = zondag',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3361 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `codes`
--

LOCK TABLES `codes` WRITE;
/*!40000 ALTER TABLE `codes` DISABLE KEYS */;
INSERT INTO `codes` VALUES (2443,139,1),(2444,176,1),(2445,135,1),(2446,186,1),(2447,168,1),(2448,135,1),(2449,168,1),(2450,135,1),(2451,178,1),(2452,135,1),(2453,136,1),(2454,135,1),(2455,175,1),(2456,165,1),(2457,110,1),(2458,135,1),(2459,175,1),(2460,135,1),(2461,135,1),(2462,23,1),(2463,135,1),(2464,178,1),(2465,110,1),(2466,110,1),(2467,110,1),(2468,8,1),(2469,168,1),(2470,111,1),(2471,135,1),(2472,135,1),(2473,176,1),(2474,178,1),(2475,211,1),(2476,135,1),(2477,96,1),(2478,73,1),(2479,42,1),(2480,8,1),(2481,135,1),(2482,135,1),(2483,105,1),(2484,110,1),(2485,135,1),(2486,135,1),(2487,211,1),(2488,135,1),(2489,176,1),(2490,28,1),(2491,135,1),(2492,135,1),(2493,137,1),(2494,60,1),(2495,31,1),(2496,187,1),(2497,137,1),(2498,14,1),(2499,135,1),(2500,137,1),(2501,168,1),(2502,80,1),(2503,126,1),(2504,211,1),(2505,85,1),(2506,135,1),(2507,205,1),(2508,135,1),(2509,156,1),(2510,137,1),(2511,135,1),(2512,176,1),(2513,110,1),(2514,135,1),(2515,135,1),(2516,135,1),(2517,175,1),(2518,198,1),(2519,154,1),(2520,135,1),(2521,135,1),(2522,78,1),(2523,135,1),(2524,93,1),(2525,110,1),(2526,93,1),(2527,178,1),(2528,158,1),(2529,175,1),(2530,143,1),(2531,135,1),(2532,135,1),(2533,176,1),(2534,176,1),(2535,135,1),(2536,135,1),(2537,135,1),(2538,186,1),(2539,135,1),(2540,189,1),(2541,186,1),(2542,201,1),(2543,192,1),(2544,17,1),(2545,134,1),(2546,135,1),(2547,176,1),(2548,137,1),(2549,189,1),(2550,186,1),(2551,135,1),(2552,166,1),(2553,168,1),(2554,8,1),(2555,190,1),(2556,135,1),(2557,135,1),(2558,101,1),(2559,5,1),(2560,103,1),(2561,168,1),(2562,65,1),(2563,211,1),(2564,135,1),(2565,172,1),(2566,135,1),(2567,135,1),(2568,48,1),(2569,135,1),(2570,135,1),(2571,90,1),(2572,7,1),(2573,149,1),(2574,8,1),(2575,135,1),(2576,135,1),(2577,173,1),(2578,135,1),(2579,168,1),(2580,135,1),(2581,176,1),(2582,168,1),(2583,135,1),(2584,110,1),(2585,176,1),(2586,160,1),(2587,157,1),(2588,155,1),(2589,110,1),(2590,135,1),(2591,113,1),(2592,135,1),(2593,93,1),(2594,134,1),(2595,159,1),(2596,135,1),(2597,176,1),(2598,176,1),(2599,175,1),(2600,203,1),(2601,67,1),(2602,135,1),(2603,135,1),(2604,168,1),(2605,135,1),(2606,57,1),(2607,7,1),(2608,176,1),(2609,135,1),(2610,168,1),(2611,26,1),(2612,137,1),(2613,135,1),(2614,8,1),(2615,135,1),(2616,122,1),(2617,186,1),(2618,135,1),(2619,8,1),(2620,109,1),(2621,76,1),(2622,135,1),(2623,102,1),(2624,190,1),(2625,168,1),(2626,135,1),(2627,134,1),(2628,135,1),(2629,186,1),(2630,135,1),(2631,132,1),(2632,183,1),(2633,50,1),(2634,56,1),(2635,135,1),(2636,135,1),(2637,168,1),(2638,135,1),(2639,135,1),(2640,113,1),(2641,110,1),(2642,165,1),(2643,168,1),(2644,95,1),(2645,135,1),(2646,137,1),(2647,135,1),(2648,135,1),(2649,168,1),(2650,135,1),(2651,135,1),(2652,135,1),(2653,8,1),(2654,135,1),(2655,135,1),(2656,98,1),(2657,110,1),(2658,135,1),(2659,175,1),(2660,135,1),(2661,181,1),(2662,137,1),(2663,75,1),(2664,211,1),(2665,139,1),(2666,175,1),(2667,194,1),(2668,176,1),(2669,135,1),(2670,135,1),(2671,145,1),(2672,175,1),(2673,168,1),(2674,10,1),(2675,45,1),(2676,138,1),(2677,162,1),(2678,168,1),(2679,78,1),(2680,135,1),(2681,33,1),(2682,136,1),(2683,135,1),(2684,8,1),(2685,135,1),(2686,135,1),(2687,58,1),(2688,176,1),(2689,134,1),(2690,71,1),(2691,135,1),(2692,135,1),(2693,168,1),(2694,141,1),(2695,29,1),(2696,135,1),(2697,106,1),(2698,186,1),(2699,113,1),(2700,135,1),(2701,135,1),(2702,135,1),(2703,135,1),(2704,168,1),(2705,135,1),(2706,110,1),(2707,135,1),(2708,37,1),(2709,135,1),(2710,8,1),(2711,84,1),(2712,119,1),(2713,135,1),(2714,87,1),(2715,176,1),(2716,148,1),(2717,135,1),(2718,95,1),(2719,135,1),(2720,91,1),(2721,186,1),(2722,168,1),(2723,72,1),(2724,116,1),(2725,176,1),(2726,168,1),(2727,8,1),(2728,135,1),(2729,127,1),(2730,130,1),(2731,43,1),(2732,9,1),(2733,134,1),(2734,176,1),(2735,135,1),(2736,188,1),(2737,134,1),(2738,211,1),(2739,38,1),(2740,189,1),(2741,72,1),(2742,135,1),(2743,135,1),(2744,210,1),(2745,92,1),(2746,135,2),(2747,78,2),(2748,178,2),(2749,168,2),(2750,113,2),(2751,8,2),(2752,135,2),(2753,186,2),(2754,135,2),(2755,24,2),(2756,135,2),(2757,175,2),(2758,175,2),(2759,178,2),(2760,139,2),(2761,211,2),(2762,191,2),(2763,72,2),(2764,8,2),(2765,186,2),(2766,135,2),(2767,135,2),(2768,85,2),(2769,135,2),(2770,101,2),(2771,89,2),(2772,135,2),(2773,176,2),(2774,135,2),(2775,135,2),(2776,130,2),(2777,137,2),(2778,150,2),(2779,157,2),(2780,8,2),(2781,186,2),(2782,8,2),(2783,176,2),(2784,113,2),(2785,7,2),(2786,135,2),(2787,135,2),(2788,176,2),(2789,135,2),(2790,135,2),(2791,134,2),(2792,135,2),(2793,168,2),(2794,140,2),(2795,137,2),(2796,135,2),(2797,135,2),(2798,168,2),(2799,135,2),(2800,195,2),(2801,168,2),(2802,178,2),(2803,78,2),(2804,44,2),(2805,135,2),(2806,168,2),(2807,211,2),(2808,135,2),(2809,135,2),(2810,211,2),(2811,163,2),(2812,164,2),(2813,135,2),(2814,186,2),(2815,93,2),(2816,135,2),(2817,186,2),(2818,169,2),(2819,186,2),(2820,135,2),(2821,135,2),(2822,11,2),(2823,159,2),(2824,7,2),(2825,92,2),(2826,135,2),(2827,135,2),(2828,41,2),(2829,133,2),(2830,135,2),(2831,135,2),(2832,211,2),(2833,110,2),(2834,157,2),(2835,8,2),(2836,175,2),(2837,200,2),(2838,110,2),(2839,135,2),(2840,110,2),(2841,134,2),(2842,135,2),(2843,135,2),(2844,135,2),(2845,108,2),(2846,156,2),(2847,168,2),(2848,181,2),(2849,135,2),(2850,36,2),(2851,176,2),(2852,135,2),(2853,211,2),(2854,55,2),(2855,168,2),(2856,138,2),(2857,135,2),(2858,59,2),(2859,6,2),(2860,135,2),(2861,168,2),(2862,135,2),(2863,176,2),(2864,135,2),(2865,135,2),(2866,5,2),(2867,176,2),(2868,184,2),(2869,135,2),(2870,49,2),(2871,70,2),(2872,135,2),(2873,135,2),(2874,135,2),(2875,168,2),(2876,34,2),(2877,39,2),(2878,147,2),(2879,189,2),(2880,137,2),(2881,207,2),(2882,135,2),(2883,190,2),(2884,135,2),(2885,110,2),(2886,135,2),(2887,71,2),(2888,136,2),(2889,84,2),(2890,135,2),(2891,168,2),(2892,110,2),(2893,135,2),(2894,175,2),(2895,64,2),(2896,63,2),(2897,100,2),(2898,134,2),(2899,137,2),(2900,93,2),(2901,186,2),(2902,135,2),(2903,185,2),(2904,135,2),(2905,168,2),(2906,28,2),(2907,211,2),(2908,90,2),(2909,134,2),(2910,83,2),(2911,176,2),(2912,135,2),(2913,189,2),(2914,176,2),(2915,112,2),(2916,168,2),(2917,137,2),(2918,120,2),(2919,168,2),(2920,135,2),(2921,175,2),(2922,135,2),(2923,202,2),(2924,135,2),(2925,206,2),(2926,135,2),(2927,135,2),(2928,162,2),(2929,134,2),(2930,158,2),(2931,86,2),(2932,97,2),(2933,168,2),(2934,142,2),(2935,135,2),(2936,196,2),(2937,135,2),(2938,23,2),(2939,176,2),(2940,135,2),(2941,96,2),(2942,110,2),(2943,135,2),(2944,110,2),(2945,137,2),(2946,181,2),(2947,135,2),(2948,135,2),(2949,135,2),(2950,135,2),(2951,43,2),(2952,96,2),(2953,137,2),(2954,186,2),(2955,138,2),(2956,135,2),(2957,176,2),(2958,128,2),(2959,139,2),(2960,31,2),(2961,176,2),(2962,136,2),(2963,176,2),(2964,135,2),(2965,91,2),(2966,135,2),(2967,135,2),(2968,135,2),(2969,81,2),(2970,176,2),(2971,135,2),(2972,110,2),(2973,168,2),(2974,135,2),(2975,135,2),(2976,135,2),(2977,135,2),(2978,110,2),(2979,176,2),(2980,171,2),(2981,189,2),(2982,175,2),(2983,135,2),(2984,79,2),(2985,95,2),(2986,135,2),(2987,93,2),(2988,110,2),(2989,117,2),(2990,135,2),(2991,176,2),(2992,135,2),(2993,110,2),(2994,93,2),(2995,135,2),(2996,135,2),(2997,114,2),(2998,135,2),(2999,72,2),(3000,135,2),(3001,84,2),(3002,8,2),(3003,98,2),(3004,135,2),(3005,130,2),(3006,8,2),(3007,167,2),(3008,168,2),(3009,135,2),(3010,95,2),(3011,135,2),(3012,135,2),(3013,135,2),(3014,137,2),(3015,18,2),(3016,168,2),(3017,135,2),(3018,175,2),(3019,32,2),(3020,19,2),(3021,79,2),(3022,135,2),(3023,46,2),(3024,8,2),(3025,135,2),(3026,135,2),(3027,135,2),(3028,144,2),(3029,103,2),(3030,8,2),(3031,52,2),(3032,182,2),(3033,186,2),(3034,134,2),(3035,178,2),(3036,113,2),(3037,135,2),(3038,103,2),(3039,131,2),(3040,110,2),(3041,168,2),(3042,168,2),(3043,135,2),(3044,9,2),(3045,8,2),(3046,135,2),(3047,176,2),(3048,162,2),(3049,129,2),(3050,176,2),(3051,135,2),(3052,175,2),(3053,135,2),(3054,135,2),(3055,168,2),(3056,135,2),(3057,138,3),(3058,135,3),(3059,118,3),(3060,175,3),(3061,135,3),(3062,135,3),(3063,134,3),(3064,51,3),(3065,135,3),(3066,161,3),(3067,135,3),(3068,135,3),(3069,135,3),(3070,177,3),(3071,34,3),(3072,135,3),(3073,40,3),(3074,135,3),(3075,137,3),(3076,168,3),(3077,145,3),(3078,93,3),(3079,135,3),(3080,135,3),(3081,130,3),(3082,135,3),(3083,30,3),(3084,137,3),(3085,180,3),(3086,135,3),(3087,176,3),(3088,8,3),(3089,97,3),(3090,135,3),(3091,135,3),(3092,164,3),(3093,168,3),(3094,135,3),(3095,134,3),(3096,176,3),(3097,144,3),(3098,135,3),(3099,168,3),(3100,121,3),(3101,43,3),(3102,135,3),(3103,176,3),(3104,74,3),(3105,139,3),(3106,110,3),(3107,22,3),(3108,123,3),(3109,110,3),(3110,137,3),(3111,8,3),(3112,157,3),(3113,168,3),(3114,176,3),(3115,82,3),(3116,186,3),(3117,134,3),(3118,135,3),(3119,135,3),(3120,110,3),(3121,168,3),(3122,124,3),(3123,110,3),(3124,135,3),(3125,72,3),(3126,189,3),(3127,77,3),(3128,135,3),(3129,134,3),(3130,135,3),(3131,204,3),(3132,8,3),(3133,7,3),(3134,178,3),(3135,135,3),(3136,99,3),(3137,176,3),(3138,7,3),(3139,162,3),(3140,135,3),(3141,135,3),(3142,135,3),(3143,44,3),(3144,135,3),(3145,43,3),(3146,88,3),(3147,135,3),(3148,107,3),(3149,211,3),(3150,189,3),(3151,8,3),(3152,15,3),(3153,176,3),(3154,110,3),(3155,197,3),(3156,135,3),(3157,12,3),(3158,135,3),(3159,135,3),(3160,178,3),(3161,168,3),(3162,175,3),(3163,135,3),(3164,69,3),(3165,8,3),(3166,68,3),(3167,25,3),(3168,135,3),(3169,168,3),(3170,27,3),(3171,190,3),(3172,135,3),(3173,125,3),(3174,135,3),(3175,181,3),(3176,168,3),(3177,176,3),(3178,134,3),(3179,176,3),(3180,159,3),(3181,156,3),(3182,175,3),(3183,175,3),(3184,96,3),(3185,93,3),(3186,175,3),(3187,175,3),(3188,135,3),(3189,176,3),(3190,135,3),(3191,16,3),(3192,110,3),(3193,137,3),(3194,8,3),(3195,176,3),(3196,138,3),(3197,168,3),(3198,176,3),(3199,135,3),(3200,175,3),(3201,135,3),(3202,168,3),(3203,135,3),(3204,135,3),(3205,176,3),(3206,135,3),(3207,93,3),(3208,135,3),(3209,20,3),(3210,55,3),(3211,176,3),(3212,199,3),(3213,168,3),(3214,113,3),(3215,135,3),(3216,135,3),(3217,85,3),(3218,176,3),(3219,175,3),(3220,77,3),(3221,135,3),(3222,135,3),(3223,135,3),(3224,135,3),(3225,110,3),(3226,92,3),(3227,135,3),(3228,135,3),(3229,135,3),(3230,135,3),(3231,162,3),(3232,193,3),(3233,135,3),(3234,110,3),(3235,135,3),(3236,135,3),(3237,157,3),(3238,135,3),(3239,53,3),(3240,168,3),(3241,135,3),(3242,186,3),(3243,135,3),(3244,104,3),(3245,135,3),(3246,103,3),(3247,181,3),(3248,8,3),(3249,164,3),(3250,135,3),(3251,135,3),(3252,153,3),(3253,8,3),(3254,211,3),(3255,135,3),(3256,110,3),(3257,110,3),(3258,135,3),(3259,135,3),(3260,135,3),(3261,136,3),(3262,135,3),(3263,168,3),(3264,31,3),(3265,13,3),(3266,142,3),(3267,152,3),(3268,96,3),(3269,135,3),(3270,190,3),(3271,186,3),(3272,94,3),(3273,137,3),(3274,135,3),(3275,186,3),(3276,135,3),(3277,179,3),(3278,135,3),(3279,135,3),(3280,135,3),(3281,110,3),(3282,135,3),(3283,135,3),(3284,168,3),(3285,135,3),(3286,131,3),(3287,174,3),(3288,110,3),(3289,158,3),(3290,211,3),(3291,62,3),(3292,6,3),(3293,135,3),(3294,84,3),(3295,137,3),(3296,168,3),(3297,31,3),(3298,146,3),(3299,168,3),(3300,135,3),(3301,135,3),(3302,135,3),(3303,137,3),(3304,135,3),(3305,113,3),(3306,151,3),(3307,186,3),(3308,135,3),(3309,176,3),(3310,135,3),(3311,135,3),(3312,209,3),(3313,186,3),(3314,178,3),(3315,134,3),(3316,211,3),(3317,135,3),(3318,135,3),(3319,23,3),(3320,176,3),(3321,135,3),(3322,186,3),(3323,135,3),(3324,135,3),(3325,176,3),(3326,135,3),(3327,186,3),(3328,176,3),(3329,115,3),(3330,135,3),(3331,8,3),(3332,170,3),(3333,168,3),(3334,8,3),(3335,211,3),(3336,135,3),(3337,168,3),(3338,135,3),(3339,156,3),(3340,168,3),(3341,211,3),(3342,168,3),(3343,54,3),(3344,135,3),(3345,135,3),(3346,91,3),(3347,95,3),(3348,66,3),(3349,135,3),(3350,61,3),(3351,135,3),(3352,135,3),(3353,47,3),(3354,103,3),(3355,90,3),(3356,178,3),(3357,208,3),(3358,35,3),(3359,135,3),(3360,186,3);
/*!40000 ALTER TABLE `codes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `scanned`
--

DROP TABLE IF EXISTS `scanned`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `scanned` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `itemId` int(11) DEFAULT NULL,
  `code` int(11) DEFAULT NULL,
  `scannedTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `scanned`
--

LOCK TABLES `scanned` WRITE;
/*!40000 ALTER TABLE `scanned` DISABLE KEYS */;
INSERT INTO `scanned` VALUES (1,176,2444,'2010-09-28 19:42:26'),(2,135,2450,'2010-09-28 19:42:39');
/*!40000 ALTER TABLE `scanned` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2010-09-28 21:53:10
